409
How can I display a different caption in the label area

With ComboBox1
	.BeginUpdate 
	.Style = 2
	.IntegralHeight = True
	.HeaderVisible = False
	.SingleEdit = True
	.SearchColumnIndex = -1
	.AdjustSearchColumn = False
	.Columns.Add("Language").Def(0) = True
	With .Items
		.AddItem "English"
		.AddItem "Hebrew"
		.AddItem "Spanish"
	End With
	.LabelText = " <b>custom</b> text "
	.EndUpdate 
End With
160
How can I display a custom size picture to a cell or item

With ComboBox1
	.DefaultItemHeight = 48
	.Columns.Add "C1"
	With .Items
		.CellPicture(.AddItem("Text"),0) = ComboBox1.ExecuteTemplate("loadpicture(`c:\exontrol\images\zipdisk.gif`)")
	End With
End With
210
How can I display a computed column and highlight some values that are negative or less than a value

With ComboBox1
	.Columns.Add "A"
	.Columns.Add "B"
	.Columns.Add("(A+B)*1.19").ComputedField = "(%0 + %1) * 1.19"
	With .Items
		.CellCaption(.AddItem(1),1) = 2
	End With
	With .Items
		.CellCaption(.AddItem(10),1) = 20
	End With
	Set var_ConditionalFormat = .ConditionalFormats.Add("%2 > 10")
	With var_ConditionalFormat
		.Bold = True
		.ForeColor = RGB(255,0,0)
		.ApplyTo = 2 ' &H2
	End With
End With
276
How can I display a button inside the item or cell

With ComboBox1
	.Columns.Add "C1"
	.Columns.Add "C2"
	With .Items
		h = .AddItem("Cell 1")
		.CellCaption(h,1) = " Button 1 "
		.CellHAlignment(h,1) = 2
		.CellHasButton(h,1) = True
		h = .AddItem("Cell 2")
		.CellCaption(h,1) = " Button 2 "
		.CellHAlignment(h,1) = 1
		.CellHasButton(h,1) = True
	End With
End With
203
How can I customize the items being displayed in the drop down filter window

With ComboBox1
	With .Columns.Add("Custom Filter")
		.DisplayFilterButton = True
		.DisplayFilterPattern = False
		.CustomFilter = "Excel Spreadsheets (*.xls )||*.xls|||Word Documents||*.doc|||Powerpoint Presentations||*.pps|||Text Documents (*.log,*.txt)||*." & _
	"txt|*.log"
		.FilterType = 3
		.Filter = "*.xls"
	End With
	.Items.AddItem "excel.xls"
	.Items.AddItem "word.doc"
	.Items.AddItem "pp.pps"
	.Items.AddItem "text.txt"
	.ApplyFilter 
End With
549
How can I create a new ADO recordset

With ComboBox1
	.BeginUpdate 
	Set rs = CreateObject("ADODB.Recordset")
	With rs
		.Fields.Append "A",8
		.Fields.Append "B",8
		.Open 
		.AddNew 
		.Fields.Item("A").Value = "Item A.1"
		.Fields.Item("B").Value = "Item B.1"
		.Update 
		.AddNew 
		.Fields.Item("A").Value = "Item A.2"
		.Fields.Item("B").Value = "Item B.2"
		.Update 
	End With
	.DataSource = rs
	.Value = "Item A.1"
	.EndUpdate 
End With
372
How can I convert the expression to a string so I can look into the date string expression for month's name

With ComboBox1
	.Columns.Add "Number"
	.Columns.Add("Str").ComputedField = "str(%0) + ' AA'"
	With .Items
		.AddItem "-1.98"
		.AddItem "0.99"
		.AddItem "1.23"
		.AddItem "2.34"
	End With
End With
427
How can I collapse all items

With ComboBox1
	.BeginUpdate 
	.LinesAtRoot = -1
	.Columns.Add "Items"
	With .Items
		h = .AddItem("Root 1")
		.InsertItem h,,"Child 1"
		.InsertItem h,,"Child 2"
		h = .AddItem("Root 2")
		.InsertItem h,,"Child 1"
		.InsertItem h,,"Child 2"
		.ExpandItem(0) = False
	End With
	.EndUpdate 
End With
340
How can I close the drop down window when user double clicks it

With ComboBox1
	.CloseOnDblClk = True
	.LinesAtRoot = 1
	.TreeColumnIndex = 1
	.Columns.Add "Column 1"
	.Columns.Add "Column 2"
	With .Items
		h = .AddItem("Root 1.1")
		.CellCaption(h,1) = "Root 1.2"
		.CellCaption(.InsertItem(h,,"Child 1.1"),1) = "Child 1.2"
		.CellCaption(.InsertItem(h,,"Child 2.1"),1) = "Child 2.2"
		.ExpandItem(h) = True
		h = .AddItem("Root 2.1")
		.CellCaption(h,1) = "Root 2.2"
		.CellCaption(.InsertItem(h,,"Child 1.1"),1) = "Child 1.2"
	End With
End With
384
How can I check the hour part only so I know it was afternoon

With ComboBox1
	.ConditionalFormats.Add("hour(%0)>=12").Bold = True
	.Columns.Add "Date"
	.Columns.Add("Hour").ComputedField = "hour(%0)"
	With .Items
		.AddItem #1/11/2001 10:00:00 AM#
		.AddItem #2/22/2002 11:00:00 AM#
		.AddItem #3/13/2003 0:00:00 PM#
		.AddItem #4/14/2004 1:00:00 PM#
	End With
End With
4
How can I change/rename the column's name

With ComboBox1
	.Columns.Add("ColumnName").Caption = "NewName"
End With
134
How can I change the width of the columns being displayed in the sort bar

With ComboBox1
	.SortBarVisible = True
	.SortBarColumnWidth = 48
	.Columns.Add("C1").SortOrder = 1
	.Columns.Add("C2").SortOrder = 2
End With
510
How can I change the visual appearance of the filter bar's close button (solid)

With ComboBox1
	.BeginUpdate 
	.Columns.Add("Item").DisplayFilterButton = True
	With .Columns.Add("Pos")
		.AllowSizing = False
		.AllowSort = False
		.Width = 32
		.FormatColumn = "1 apos ``"
		.Position = 0
	End With
	With .Items
		.AddItem "Item A"
		.AddItem "Item B"
		.AddItem "Item C"
	End With
	.FilterBarPromptVisible = 1
	.Background(1) = RGB(255,0,0)
	.EndUpdate 
End With
511
How can I change the visual appearance of the filter bar's close button (EBN)

With ComboBox1
	.BeginUpdate 
	With .VisualAppearance
		.Add 1,"gBFLBCJwBAEHhEJAAEhABHQDg6AADACAxRDgMQBQKAAzAJBIYhiG4cYCgMZhXDOCYXABCEYRXBIZQ7BKNIxjSJ5BhIAAyDSJMjSRJUEhqGCWYDleYYYAKHIMQLOg7IJ" & _
	"jyI4/SJAYCydKAWhxIaZKJHCZoEDaTAADCNVAQp6MEIJVbVEI0e79OgBLp/Z7kECIJJAaRjHQdJxGLA8EhtCQhCZteK6SgMKJYXhWQYRXI1JwvMBrWrdQjiOYELQtMKm" & _
	"SZNLYGG4dR5SVJbcYhSYsRRFMoyDIOXYDLKsdYqSpXIThObEGgaPqJYjsUjCMKnR7HVIURrBPC9TBPE69ZgmC6ucKPX51ShKFaBWDZcwFAS+UBuYCAILiEAQGZ1XT8OR" & _
	"OicbgJgSTJRlCaZeDsHY7QGR4xkSYp3CaExZAQMgalQYAwjCAAfBANxcA2TgKAUOpDCGFhKg0RpXCwCwDHQHQHEyAIkCkOhbFOGA8A8DohBgRg9AccZcn8EpEjMLI2C2" & _
	"DYxAgQgvAIUIVkoAAPBQDJlECTZ3CCYwDACQwUA8A5MCAWAWDiQi4l8aQOEgLJuBgBgDmYFAzEoIoIl0WALgKYJbBABADAAHgHg8VAMmqCQQDMXABAATYwTmNwBDATJX" & _
	"AiAgjHmNQ5lgQ5QEQEQMmcWg/GwD5ylyNw2gMcJcjsBgBgOQQDDhRpVAMMwnDBFw1B0Ax8D0DxOmmJJIGQTY5hGMAwkwM4CAYLZAmAOJnAqAojiIGg6iieYkmeAYOHaK" & _
	"JDCyCwjH6AoggsQpQliAJLhgaJ0CESBTnyDwjk+cg4g4P5IHIHJ+BWRRzlYWAxiOUxihsY4KjKLJRGqC44FCegkkkM58iAKAPnIWIWD8SRSFSfQnkmewUhYP4GiGKJ7G" & _
	"0TIbCSUoggqUo0lAQ4LnEcBcD8Coiiif4nE+eAAn2HpOkcFJqi4T5SkyMw/kqQown8IBIBOdA+A+DJrBqVxXEqYo4lCApLhGHBnD8S4ymyfxmg+cwQkQP5egOUZIWoEA" & _
	"kjIeIPBMBJBD+TBjBifwvkuc58hQJQPmFrYykkchclSApKjGOBuD+TRDFCfw3mmIxNi8FxFlOXhVC4aYDFyPgvg2YBcBcLZGCGCJ0DSLRzGSWQ/lmY5+mEP5gmMDBZRS" & _
	"MRsFsOxMhMJJ/DsTpTnwaQaE+N5ojuNhdEYNI5C4TZJO1GRDmCaxnA2Yx4n8IpIjOTBQBQC5TgyYw7gUYRYikC0BYRwsDQBoB8eA6Q2hsE0BUXgywZtYCyHMKwnxSAhA" & _
	"QHkIQhRrBaDsCwA4ERiB2EWAIYIXhhiVEgAEUYwwYjyASLge4FhHgRDkM8OQih0jWPkGgBBAQ"
	End With
	.Columns.Add("Item").DisplayFilterButton = True
	With .Columns.Add("Pos")
		.AllowSizing = False
		.AllowSort = False
		.Width = 32
		.FormatColumn = "1 apos ``"
		.Position = 0
	End With
	With .Items
		.AddItem "Item A"
		.AddItem "Item B"
		.AddItem "Item C"
	End With
	.FilterBarPromptVisible = 257 ' FilterBarVisibleEnum.exFilterBarToggle Or FilterBarVisibleEnum.exFilterBarPromptVisible
	.Background(1) = &H1000000
	.EndUpdate 
End With
131
How can I change the visual appearance of the control's sort bar, using EBN files

With ComboBox1
	.VisualAppearance.Add 1,"c:\exontrol\images\normal.ebn"
	.VisualAppearance.Add 2,"c:\exontrol\images\pushed.ebn"
	.SortBarVisible = True
	.BackColorSortBar = &H1000000
	.BackColorSortBarCaption = &H2000000
	.Appearance = 0
End With
499
How can I change the visual appearance of the +/- buttons, open/close glyphs as current visual theme (method 3)

With ComboBox1
	.BeginUpdate 
	With .VisualAppearance
		.Add 3,"gBFLBCJwBAEHhEJAAEhABDwCg6AADACAxRDgMQBQKAAzAJBIYhiG4cYCgMZhXDOCYXABCEYRXBIZQ7BKNIxjSJ5BhIAAyDSJMjSRJUEhqGCWYDleYYYAKHIMQLJQKQS" & _
	"BcQR9EaBZBAWTpQC0OJDTJRI4TNAgbSYAAYRqoCb6loTKypaxjCQQIgkUBpGKdBynEYsDwSGyJCCJWyIbpKAwoVbcs4AYhuJpaQi+d5PFbjVT8dLAMBwLA8EwXAJ+Opf" & _
	"DxXU7eFKpR5fchXTI8UxXFqXZhkeQrfh7KYVRBKdBQRBEFQPJqnahqOpaXo2RoLUJKcQwHTmHYNQTALyuTALZrWeZ3XrgN74LbtZzVQauYRpbCMEr6bpoWLnFi6Ho1U4" & _
	"llWah1jqSweFqfxPgQQRphi+Yak0YIuqUfJegef4zluaJ3nqPJeCYH4BAeX5TDLBpVGqKRRnwf4flefZtHsX54BYAR/F+EwVnUd5eAMMJKDIChygyIQpAoEh4iIJ5Jlg" & _
	"XIcgCXpIGoFwnGEQh6BEKBgmMIICHgIJCAiUAzgyUoAhwJohkiRgygwYpiGoKwzGIcgKCkNQNCMRIbCYCRYk4QoMiOchWDwNBjhiJJaDYTRiGiFwlCQAhOE8JBJHITIR" & _
	"gwZRZFCFCZBkOIUhKTRpCWAwgGYQ4El4NxlBifIWCcCYCFoaoMGaKYyG6GxlBmGJdhkCAWBIeA5g4U4QhMJAImkPIShRVxGgQJRlCIUISh+SJpnCZIeBgFgiHgO4OlOM" & _
	"INCISByECDQikkGhuh2JwpmqBogCKaYiC6FwhmkQ4yHgYgYiaHopiuaRakCbIsisSpGjYOwaHYKYMCkK5CA2IxrCwCwFigaJrkLTI6lcdANAEgIA="
		.Add 1,"CP:3 -2 -2 2 2"
		.Add 4,"gBFLBCJwBAEHhEJAAEhABEICg6AADACAxRDgMQBQKAAzAJBIYhiG4cYCgMZhXDOCYXABCEYRXBIZQ7BKNIxjSJ5BhIAAyDSJMjSRJUEhqGCWYDleYYYAKHIMQLJQKQS" & _
	"BcQR9EaBZBAWTpQC0OJDTJRI4TNAgbSYAAYRqoCb6loTKypaxjCQQIgkUBpGKdBynEYsDwSGyJCCJWyIbpKAwoVbcs4AYhuJpaQi+d5PFbjVT8dLAMBwLA8EwXAJ+Opf" & _
	"DxXU7eFKpR5fchXTI8UxXFqXZhkeQrfh7KYVRBKdBQRBEFQPJqnahqOpaXo2RoLUJKcQwHTmHYNQTALyuTALZrWeZ3XrgN74LbtZzVQauYRpbCMEr6bpoWLnFi6Ho1U4" & _
	"llWah1jqSweFqfxPgQQRphi+Yak0YIuqUfJeg8X4rluaZ3niGB+AQHx/EyShjjEVYqiUR5rnmex/GAB5+AIf4gEeXJFHyXZ3gCTAygyAociMKBKEKBIeCiCZyHYFAnCE" & _
	"eBkh+BghFgRIegOCgYCySAgh4CAkgINAMmMNIgCcCYjn4LoLmMCJGDKC5ijIagoDMYhCAoJg1A0IxEhsJgJFiThChCY5yFYPA0GOGIYloNhNGIaIXCUJACE4TwkEkchO" & _
	"FSFYlFkXhUCUCQZEYTglCSMxaEkYJIBmFJhDeDZZEYPwlgmQhghaGqVDoa4bGaeY6FGGZNlmFIBGEJ4jhiZQ5AkMhAg6E5JCkRoGCUSQ6B6CYiSCBIOh+DhJmmARiWQO" & _
	"JtDsCJSCSBwkXSLIRicaZ6HqIIomoIguhwIpphIHoWDsJ4mCGChpmqOpGheLIOkqUo2iya4DjGJxihiQoSj4IJaDaMpCjCWoGg6PgpBiQ4tHcQJQBAgI="
		.Add 2,"CP:4 -2 -2 2 2"
	End With
	.LinesAtRoot = 1
	.HasButtons = 4
	.HasButtonsCustom(0) = 16777216
	.HasButtonsCustom(1) = 33554432
	.Columns.Add "Column"
	With .Items
		h = .AddItem("Root 1")
		.InsertItem h,,"Child 1"
		.InsertItem h,,"Child 2"
		.ExpandItem(h) = True
		h = .AddItem("Root 2")
		.InsertItem h,,"Child"
	End With
	.EndUpdate 
End With
498
How can I change the visual appearance of the +/- buttons, open/close glyphs as current visual theme (method 2)

With ComboBox1
	.BeginUpdate 
	With .VisualAppearance
		.Add 1,"XP:TREEVIEW 2 1"
		.Add 2,"XP:TREEVIEW 2 2"
	End With
	.Background(180) = &H1000000
	.Background(181) = &H2000000
	.LinesAtRoot = -1
	.Columns.Add "Column"
	With .Items
		h = .AddItem("Root 1")
		.InsertItem h,,"Child 1"
		.InsertItem h,,"Child 2"
		.ExpandItem(h) = True
		h = .AddItem("Root 2")
		.InsertItem h,,"Child"
	End With
	.EndUpdate 
End With
496
How can I change the visual appearance of the +/- buttons (method 1)

With ComboBox1
	.BeginUpdate 
	With .VisualAppearance
		.Add 1,"gBFLBCJwBAEHhEJAAEhABDwCg6AADACAxRDgMQBQKAAzAJBIYhiG4cYCgMZhXDOCYXABCEYRXBIZQ7BKNIxjSJ5BhIAAyDSJMjSRJUEhqGCWYDleYYYAKHIMQLJQKQS" & _
	"BcQR9EaBZBAWTpQC0OJDTJRI4TNAgbSYAAYRqoCb6loTKypaxjCQQIgkUBpGKdBynEYsDwSGyJCCJWyIbpKAwoVbcs4AYhuJpaQi+d5PFbjVT8dLAMBwLA8EwXAJ+Opf" & _
	"DxXU7eFKpR5fchXTI8UxXFqXZhkeQrfh7KYVRBKdBQRBEFQPJqnahqOpaXo2RoLUJKcQwHTmHYNQTALyuTALZrWeZ3XrgN74LbtZzVQauYRpbCMEr6bpoWLnFi6Ho1U4" & _
	"llWah1jqSweFqfxPgQQRphi+Yak0YIuqUfJegef4zluaJ3nqPJeCYH4BAeX5TDLBpVGqKRRnwf4flefZtHsX54BYAR/F+EwVnUd5eAMMJKDIChygyIQpAoEh4iIJ5Jlg" & _
	"XIcgCXpIGoFwnGEQh6BEKBgmMIICHgIJCAiUAzgyUoAhwJohkiRgygwYpiGoKwzGIcgKCkNQNCMRIbCYCRYk4QoMiOchWDwNBjhiJJaDYTRiGiFwlCQAhOE8JBJHITIR" & _
	"gwZRZFCFCZBkOIUhKTRpCWAwgGYQ4El4NxlBifIWCcCYCFoaoMGaKYyG6GxlBmGJdhkCAWBIeA5g4U4QhMJAImkPIShRVxGgQJRlCIUISh+SJpnCZIeBgFgiHgO4OlOM" & _
	"INCISByECDQikkGhuh2JwpmqBogCKaYiC6FwhmkQ4yHgYgYiaHopiuaRakCbIsisSpGjYOwaHYKYMCkK5CA2IxrCwCwFigaJrkLTI6lcdANAEgIA="
		.Add 2,"gBFLBCJwBAEHhEJAAEhABEICg6AADACAxRDgMQBQKAAzAJBIYhiG4cYCgMZhXDOCYXABCEYRXBIZQ7BKNIxjSJ5BhIAAyDSJMjSRJUEhqGCWYDleYYYAKHIMQLJQKQS" & _
	"BcQR9EaBZBAWTpQC0OJDTJRI4TNAgbSYAAYRqoCb6loTKypaxjCQQIgkUBpGKdBynEYsDwSGyJCCJWyIbpKAwoVbcs4AYhuJpaQi+d5PFbjVT8dLAMBwLA8EwXAJ+Opf" & _
	"DxXU7eFKpR5fchXTI8UxXFqXZhkeQrfh7KYVRBKdBQRBEFQPJqnahqOpaXo2RoLUJKcQwHTmHYNQTALyuTALZrWeZ3XrgN74LbtZzVQauYRpbCMEr6bpoWLnFi6Ho1U4" & _
	"llWah1jqSweFqfxPgQQRphi+Yak0YIuqUfJeg8X4rluaZ3niGB+AQHx/EyShjjEVYqiUR5rnmex/GAB5+AIf4gEeXJFHyXZ3gCTAygyAociMKBKEKBIeCiCZyHYFAnCE" & _
	"eBkh+BghFgRIegOCgYCySAgh4CAkgINAMmMNIgCcCYjn4LoLmMCJGDKC5ijIagoDMYhCAoJg1A0IxEhsJgJFiThChCY5yFYPA0GOGIYloNhNGIaIXCUJACE4TwkEkchO" & _
	"FSFYlFkXhUCUCQZEYTglCSMxaEkYJIBmFJhDeDZZEYPwlgmQhghaGqVDoa4bGaeY6FGGZNlmFIBGEJ4jhiZQ5AkMhAg6E5JCkRoGCUSQ6B6CYiSCBIOh+DhJmmARiWQO" & _
	"JtDsCJSCSBwkXSLIRicaZ6HqIIomoIguhwIpphIHoWDsJ4mCGChpmqOpGheLIOkqUo2iya4DjGJxihiQoSj4IJaDaMpCjCWoGg6PgpBiQ4tHcQJQBAgI="
	End With
	.LinesAtRoot = -1
	.Background(180) = &H1000000
	.Background(181) = &H2000000
	.Columns.Add "Column"
	With .Items
		h = .AddItem("Root 1")
		.InsertItem h,,"Child 1"
		.InsertItem h,,"Child 2"
		.ExpandItem(h) = True
		h = .AddItem("Root 2")
		.InsertItem h,,"Child"
	End With
	.EndUpdate 
End With
275
How can I change the state of a radio button

With ComboBox1
	.MarkSearchColumn = False
	.SelBackColor = RGB(255,255,128)
	.SelForeColor = RGB(0,0,0)
	.Columns.Add "C1"
	.Columns.Add "C2"
	.Columns.Add "C3"
	With .Items
		h = .AddItem("Cell 1")
		.CellCaption(h,1) = "Radio 1"
		.CellHasRadioButton(h,1) = True
		.CellRadioGroup(h,1) = 1234
		.CellCaption(h,2) = "Radio 2"
		.CellHasRadioButton(h,2) = True
		.CellRadioGroup(h,2) = 1234
		.CellState(h,1) = 1
	End With
End With
273
How can I change the state of a checkbox

With ComboBox1
	.Columns.Add "C1"
	.Columns.Add "C2"
	With .Items
		h = .AddItem("Cell 1")
		.CellCaption(h,1) = "Check Box"
		.CellHasCheckBox(h,1) = True
		.CellState(h,1) = 1
	End With
End With
132
How can I change the sort bar's foreground color

With ComboBox1
	.SortBarVisible = True
	.ForeColorSortBar = RGB(255,0,0)
End With
130
How can I change the sort bar's background color

With ComboBox1
	.SortBarVisible = True
	.BackColorSortBar = RGB(255,0,0)
	.BackColorSortBarCaption = RGB(128,0,0)
End With
289
How can I change the size ( width, height ) of the picture

With ComboBox1
	.Columns.Add "Default"
	With .Items
		h = .AddItem("Root 1")
		.CellPicture(h,0) = ComboBox1.ExecuteTemplate("loadpicture(`c:\exontrol\images\zipdisk.gif`)")
		.CellPictureWidth(h,0) = 24
		.CellPictureHeight(h,0) = 24
		.ItemHeight(h) = 32
		h = .AddItem("Root 2")
		.CellPicture(h,0) = ComboBox1.ExecuteTemplate("loadpicture(`c:\exontrol\images\zipdisk.gif`)")
		.ItemHeight(h) = 48
	End With
End With
32
How can I change the position of the column

With ComboBox1
	.Columns.Add "Column 1"
	.Columns.Add("Column 2").Position = 0
End With
298
How can I change the position of an item

With ComboBox1
	.Columns.Add "Default"
	With .Items
		.AddItem "Item 1"
		.AddItem "Item 2"
		.ItemPosition(.AddItem("Item 3")) = 0
	End With
End With
202
How can I change the order or the position of the columns in the sort bar

With ComboBox1
	.SortBarVisible = True
	.SortBarColumnWidth = 48
	.Columns.Add("C1").SortOrder = 1
	.Columns.Add("C2").SortOrder = 2
	.Columns.Item("C2").SortPosition = 0
End With
48
How can I change the name of the week days in the drop down calendar window, being displayed when I filter items between dates

With ComboBox1
	With .Columns.Add("Column")
		.DisplayFilterButton = True
		.DisplayFilterDate = True
	End With
	.Description(18) = "Du Lu Ma Mi Jo Vi Si"
	.ApplyFilter 
End With
47
How can I change the name of the months in the drop down calendar window, being displayed when I filter items between dates

With ComboBox1
	With .Columns.Add("Column")
		.DisplayFilterButton = True
		.DisplayFilterDate = True
	End With
	.Description(17) = "Janvier F vrier Mars Avril Mai Juin Juillet Ao t Septembre Octobre Novembre D cembre"
	.ApplyFilter 
End With
133
How can I change the height of the sort bar's

With ComboBox1
	.SortBarVisible = True
	.SortBarHeight = 48
End With
252
How can I change the height for all items

With ComboBox1
	.DefaultItemHeight = 32
	.Columns.Add "Column"
	.Items.AddItem "One"
	.Items.AddItem "Two"
End With
124
How can I change the header's background color, when multiple levels are displayed

With ComboBox1
	.BackColorLevelHeader = RGB(250,0,0)
	.Columns.Add("S").Width = 32
	.Columns.Add("Level 1").LevelKey = 1
	.Columns.Add("Level 2").LevelKey = 1
	.Columns.Add("Level 3").LevelKey = 1
End With
344
How can I change the foreground color for edit controls

With ComboBox1
	.ForeColorEdit = RGB(255,0,0)
	.IntegralHeight = True
	.LinesAtRoot = 1
	.TreeColumnIndex = 1
	.Columns.Add "Column 1"
	.Columns.Add "Column 2"
	With .Items
		h = .AddItem("Root 1.1")
		.CellCaption(h,1) = "Root 1.2"
		.CellCaption(.InsertItem(h,,"Child 1.1"),1) = "Child 1.2"
		.CellCaption(.InsertItem(h,,"Child 2.1"),1) = "Child 2.2"
		.ExpandItem(h) = True
		h = .AddItem("Root 2.1")
		.CellCaption(h,1) = "Root 2.2"
		.CellCaption(.InsertItem(h,,"Child 1.1"),1) = "Child 1.2"
	End With
	.Select(0) = "Root 1.1"
End With
215
How can I change the foreground color for all cells in the column

With ComboBox1
	Set var_ConditionalFormat = .ConditionalFormats.Add("1")
	With var_ConditionalFormat
		.ForeColor = RGB(255,0,0)
		.ApplyTo = 0
	End With
	.Columns.Add "Column"
	.Items.AddItem 0
	.Items.AddItem 1
End With
424
How can I change the foreground color for a particular column

With ComboBox1
	With .Columns
		.Add "Column 1"
		.Add("Column 2").Def(8) = 8439039
		.Add "Column 3"
	End With
End With
300
How can I change the font for entire item
With ComboBox1
	.Columns.Add "Default"
	.Items.AddItem "default font"
	Set f = CreateObject("StdFont")
	With f
		.Name = "Tahoma"
		.Size = 12
	End With
	With .Items
		.ItemFont(.AddItem("new font")) = f
	End With
End With
217
How can I change the font for all cells in the entire column

With ComboBox1
	Set f = CreateObject("StdFont")
	With f
		.Name = "Tahoma"
		.Size = 12
	End With
	With .ConditionalFormats.Add("1")
		.Font = f
		.ApplyTo = 0
	End With
	.Columns.Add "Column"
	.Items.AddItem 0
	.Items.AddItem 1
End With
302
How can I change the font for a cell

With ComboBox1
	.Columns.Add "Default"
	.Items.AddItem "std font"
	With .Items
		.CellCaptionFormat(.AddItem("this <font tahoma;12>is a bit of text with</font> a different font"),0) = 1
	End With
End With
301
How can I change the font for a cell

With ComboBox1
	.Columns.Add "Default"
	.Items.AddItem "default font"
	Set f = CreateObject("StdFont")
	With f
		.Name = "Tahoma"
		.Size = 12
	End With
	With .Items
		.CellFont(.AddItem("new font"),0) = f
	End With
End With
129
How can I change the default caption being displayed in the control's sort bar

With ComboBox1
	.SortBarVisible = True
	.SortBarCaption = "new caption"
End With
95
How can I change the control's font

With ComboBox1
	.Font.Name = "Tahoma"
	.Columns.Add "Column"
End With
13
How can I change the column's width

With ComboBox1
	.ColumnAutoResize = False
	.Columns.Add("Column 1").Width = 64
	.Columns.Add("Column 2").Width = 128
End With
455
How can I change the color, font, bold etc for the items/cells in the same column or for the entire column

With ComboBox1
	.BeginUpdate 
	.MarkSearchColumn = False
	With .ConditionalFormats.Add("1")
		.Bold = True
		.ForeColor = RGB(255,0,0)
		.ApplyTo = 1 ' &H1
	End With
	.Columns.Add "C1"
	With .Columns.Add("C2")
		.HeaderBold = True
		.HTMLCaption = "<fgcolor=FF0000>C2"
	End With
	With .Items
		.CellCaption(.AddItem(10),1) = 11
		.CellCaption(.AddItem(12),1) = 13
	End With
	.EndUpdate 
End With
314
How can I change the color for separator / dividers items

With ComboBox1
	.MarkSearchColumn = False
	.TreeColumnIndex = -1
	.ScrollBySingleLine = False
	.Columns.Add "C1"
	.Columns.Add "C2"
	With .Items
		h = .AddItem("Cell 1")
		.CellCaption(h,1) = "This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines."
		.CellSingleLine(h,1) = False
		h = .AddItem()
		.ItemDivider(h) = 0
		.ItemDividerLine(h) = 4
		.ItemDividerLineAlignment(h) = 1
		.ItemHeight(h) = 6
		.SelectableItem(h) = False
		h = .AddItem("Cell 2")
		.CellCaption(h,1) = "This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines."
		.CellSingleLine(h,1) = False
	End With
End With
359
How can I change the background color or the visual appearance using ebn for a particular column

With ComboBox1
	.VisualAppearance.Add 1,"c:\exontrol\images\normal.ebn"
	With .Columns
		.Add "Column 1"
		.Add("Column 2").Def(7) = 16777216
		.Add("Column 3").Def(7) = 16777471
		.Add "Column 4"
	End With
End With
407
How can I change the background color for the filter field in the bottom part of the drop down portion

With ComboBox1
	.BeginUpdate 
	.FilterForVisible = True
	.FilterForBackColor = RGB(240,240,240)
	.IntegralHeight = True
	.Columns.Add "Default"
	With .Items
		.AddItem "Item 1"
		.AddItem "Item 2"
		.AddItem "Item 3"
		.AddItem "Item 4"
		.AddItem "Item 5"
	End With
	.EndUpdate 
End With
343
How can I change the background color for edit controls

With ComboBox1
	.BackColorEdit = RGB(255,0,0)
	.IntegralHeight = True
	.LinesAtRoot = 1
	.TreeColumnIndex = 1
	.Columns.Add "Column 1"
	.Columns.Add "Column 2"
	With .Items
		h = .AddItem("Root 1.1")
		.CellCaption(h,1) = "Root 1.2"
		.CellCaption(.InsertItem(h,,"Child 1.1"),1) = "Child 1.2"
		.CellCaption(.InsertItem(h,,"Child 2.1"),1) = "Child 2.2"
		.ExpandItem(h) = True
		h = .AddItem("Root 2.1")
		.CellCaption(h,1) = "Root 2.2"
		.CellCaption(.InsertItem(h,,"Child 1.1"),1) = "Child 1.2"
	End With
	.Select(0) = "Root 1.1"
End With
216
How can I change the background color for all cells in the column

With ComboBox1
	Set var_ConditionalFormat = .ConditionalFormats.Add("1")
	With var_ConditionalFormat
		.BackColor = RGB(255,0,0)
		.ApplyTo = 0
	End With
	.Columns.Add "Column"
	.Items.AddItem 0
	.Items.AddItem 1
End With
358
How can I change the background color for a particular column

With ComboBox1
	With .Columns
		.Add "Column 1"
		.Add("Column 2").Def(7) = 8439039
		.Add "Column 3"
	End With
End With
423
How can I change the background color for a particular column

With ComboBox1
	With .Columns
		.Add "Column 1"
		.Add("Column 2").Def(7) = 8439039
		.Add "Column 3"
	End With
End With
408
How can I change the background appearance (ebn) for the filter field in the bottom part of the drop down portion

With ComboBox1
	.BeginUpdate 
	.VisualAppearance.Add 1,"c:\exontrol\images\normal.ebn"
	.FilterForVisible = True
	.FilterForBackColor = &H1000000
	.IntegralHeight = True
	.Columns.Add "Default"
	With .Items
		.AddItem "Item 1"
		.AddItem "Item 2"
		.AddItem "Item 3"
		.AddItem "Item 4"
		.AddItem "Item 5"
	End With
	.EndUpdate 
End With
50
How can I change the "IsChecked/IsUnchecked" caption in the control's filter bar, when I filter for checked items

With ComboBox1
	With .Columns.Add("Column")
		.DisplayFilterButton = True
		.FilterType = 6
		.Filter = 0
	End With
	.Description(21) = "Check_On"
	.Description(22) = "Check_Off"
	.ApplyFilter 
End With
35
How can I change the "Filter For" caption in the column's drop down filter window

With ComboBox1
	.Columns.Add("Column").DisplayFilterButton = True
	.Description(3) = "new caption"
End With
49
How can I change the "Checked" caption in the drop down filter window, when I filter for checked items

With ComboBox1
	With .Columns.Add("Column")
		.DisplayFilterButton = True
		.FilterType = 6
	End With
	.Description(19) = "with check on"
	.Description(20) = "with check off"
End With
231
How can I change at runtime the parent of the item

With ComboBox1
	.LinesAtRoot = -1
	.Columns.Add "Default"
	With .Items
		hP = .AddItem("Root")
		hC = .AddItem("Child")
		.SetParent hC,hP
	End With
End With
57
How can I can I select programmatically "Blanks/NonBlanks" option in the column's drop down filter

With ComboBox1
	With .Columns.Add("Column")
		.DisplayFilterButton = True
		.FilterType = 1
	End With
	.ApplyFilter 
End With
61
How can I can I programmatically filter the checked items

With ComboBox1
	With .Columns.Add("Column")
		.Def(0) = True
		.DisplayFilterButton = True
		.FilterType = 6
		.Filter = 0
	End With
	.Items.AddItem 0
	With .Items
		.CellState(.AddItem(1),0) = 1
	End With
	.Items.AddItem 2
	.ApplyFilter 
End With
62
How can I can I programmatically filter for items with a specified icon assigned

With ComboBox1
	.Images "gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" & _
	"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" & _
	"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _
	"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="
	With .Columns.Add("Column")
		.DisplayFilterButton = True
		.FilterType = 10
		.Filter = 1
	End With
	With .Items
		.CellImage(.AddItem("Image 1"),0) = 1
		.CellImage(.AddItem("Image 1"),0) = 1
		.CellImage(.AddItem("Image 2"),0) = 2
		.CellImage(.AddItem("Image 3"),0) = 3
	End With
	.ApplyFilter 
End With
60
How can I can I filter programmatically the items based on some numerichal rules

With ComboBox1
	With .Columns.Add("Column")
		.DisplayFilterButton = True
		.FilterType = 5
		.Filter = "> 0 <= 1"
	End With
	.Items.AddItem 0
	.Items.AddItem 1
	.Items.AddItem 2
	.ApplyFilter 
End With
59
How can I can I filter programmatically the items based on a range/interval of dates

With ComboBox1
	With .Columns.Add("Column")
		.DisplayFilterButton = True
		.DisplayFilterDate = True
		.FilterType = 4
		.Filter = "1/1/2001 to 1/1/2002"
	End With
	.Items.AddItem "1/1/2001"
	.Items.AddItem "2/1/2002"
	.ApplyFilter 
End With
58
How can I can I filter programmatically given a specified pattern using wild characters like * or

With ComboBox1
	With .Columns.Add("Column")
		.DisplayFilterButton = True
		.FilterType = 3
		.Filter = "0*"
	End With
	.Items.AddItem 0
	.Items.AddItem "00"
	.Items.AddItem 1
	.Items.AddItem "11"
	.ApplyFilter 
End With
555
How can I build a "virtual" tree using your control

' BeforeExpandItem event - Fired before an item is about to be expanded (collapsed).
Private Sub ComboBox1_BeforeExpandItem(ByVal Item As Long, Cancel As Variant)
	With ComboBox1
		With .Items
			.ItemHasChildren(.InsertItem(Item,,"new")) = True
		End With
	End With
End Sub

With ComboBox1
	.BeginUpdate 
	.LinesAtRoot = -1
	.Style = 1
	.Columns.Add "Def"
	With .Items
		.AddItem "Item 1"
		.ItemHasChildren(.AddItem("Item 2")) = True
		.AddItem "Item 3"
	End With
	.Value = "Item 2"
	.EndUpdate 
End With
363
How can I bold the items that contains data or those who displays empty strings

With ComboBox1
	.ConditionalFormats.Add("not len(%1)=0").Bold = True
	.Columns.Add "C1"
	.Columns.Add "C2"
	With .Items
		h = .AddItem("Root")
		.InsertItem h,,"Child 1"
		hC = .InsertItem(h,,"Child 2")
		.CellCaption(hC,1) = "1"
		.InsertItem h,,"Child 3"
		.ExpandItem(h) = True
	End With
End With
211
How can I bold the entire column

With ComboBox1
	Set var_ConditionalFormat = .ConditionalFormats.Add("1")
	With var_ConditionalFormat
		.Bold = True
		.ApplyTo = 0
	End With
	.Columns.Add "Column"
	.Items.AddItem 0
	.Items.AddItem 1
End With
25
How can I bold only a portion of the column's header

With ComboBox1
	.Columns.Add("Column 1").HTMLCaption = "<b>Col</b>umn 1"
End With
269
How can I associate an extra data to a cell

With ComboBox1
	.Columns.Add "C1"
	.Columns.Add "C2"
	With .Items
		h = .AddItem("Cell 1")
		.CellCaption(h,1) = "Cell 2"
		.CellData(h,1) = "your extra data"
	End With
End With
280
How can I assign multiple icons/pictures to a cell

With ComboBox1
	.Images "gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" & _
	"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" & _
	"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _
	"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="
	.Columns.Add "Default"
	With .Items
		h = .AddItem("Root <img>1</img> 1, <img>2</img>, ... and so on ")
		.CellCaptionFormat(h,0) = 1
	End With
End With
279
How can I assign multiple icons/pictures to a cell

With ComboBox1
	.Images "gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" & _
	"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" & _
	"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _
	"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="
	.Columns.Add "Default"
	With .Items
		h = .AddItem("Root 1")
		.CellImages(h,0) = "1,2,3"
	End With
End With
282
How can I assign multiple icon/picture to a cell

With ComboBox1
	.HTMLPicture("p1") = "c:\exontrol\images\zipdisk.gif"
	.HTMLPicture("p2") = "c:\exontrol\images\auction.gif"
	.Columns.Add "Default"
	With .Items
		h = .AddItem("text <img>p1</img> another picture <img>p2</img> and so on")
		.CellCaptionFormat(h,0) = 1
		.CellPicture(h,0) = ComboBox1.ExecuteTemplate("loadpicture(`c:\exontrol\images\colorize.gif`)")
		.ItemHeight(h) = 48
		.AddItem "Root 2"
	End With
End With
14
How can I assign checkboxes for the entire column

With ComboBox1
	.Columns.Add("Column 1").Def(0) = True
	.Items.AddItem 0
	.Items.AddItem 1
	.Items.AddItem 2
End With
281
How can I assign an icon/picture to a cell

With ComboBox1
	.Columns.Add "Default"
	With .Items
		h = .AddItem("Root 1")
		.CellPicture(h,0) = ComboBox1.ExecuteTemplate("loadpicture(`c:\exontrol\images\zipdisk.gif`)")
		.ItemHeight(h) = 48
		.AddItem "Root 2"
	End With
End With
278
How can I assign an icon/picture to a cell

With ComboBox1
	.Images "gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" & _
	"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" & _
	"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _
	"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="
	.Columns.Add "Default"
	With .Items
		h = .AddItem("Root 1")
		.CellImage(h,0) = 1
		.CellImage(.InsertItem(h,,"Child 1"),0) = 2
		.CellImage(.InsertItem(h,,"Child 2"),0) = 3
		.ExpandItem(h) = True
	End With
End With
270
How can I assign a tooltip to a cell

With ComboBox1
	.Columns.Add "C1"
	.Columns.Add "C2"
	With .Items
		h = .AddItem("Cell 1")
		.CellCaption(h,1) = "tooltip"
		.CellToolTip(h,1) = "This is bit of text that's shown when the user hovers the cell"
	End With
End With
274
How can I assign a radio button to a cell

With ComboBox1
	.MarkSearchColumn = False
	.SelBackColor = RGB(255,255,128)
	.SelForeColor = RGB(0,0,0)
	.Columns.Add "C1"
	.Columns.Add "C2"
	.Columns.Add "C3"
	With .Items
		h = .AddItem("Cell 1")
		.CellCaption(h,1) = "Radio 1"
		.CellHasRadioButton(h,1) = True
		.CellRadioGroup(h,1) = 1234
		.CellCaption(h,2) = "Radio 2"
		.CellHasRadioButton(h,2) = True
		.CellRadioGroup(h,2) = 1234
		.CellState(h,1) = 1
	End With
End With
16
How can I assign a different background color for the entire column

With ComboBox1
	.MarkSearchColumn = False
	.Columns.Add("Column 1").Def(4) = 255
	.Columns.Add "Column 2"
	.Items.AddItem 0
	.Items.AddItem 1
	.Items.AddItem 2
End With
272
How can I assign a checkbox to a cell

With ComboBox1
	.Columns.Add "C1"
	.Columns.Add "C2"
	With .Items
		h = .AddItem("Cell 1")
		.CellCaption(h,1) = "Check Box"
		.CellHasCheckBox(h,1) = True
	End With
End With
15
How can I assign a check box for a cell

With ComboBox1
	.Columns.Add "Column 1"
	With .Items
		.AddItem 0
		.CellHasCheckBox(.AddItem(1),0) = True
		.AddItem 2
	End With
End With
30
How can I apply an strikeout font only a portion of the column's header

With ComboBox1
	.Columns.Add("Column 1").HTMLCaption = "<s>Col</s>umn 1"
End With
27
How can I apply an italic font only a portion of the column's header

With ComboBox1
	.Columns.Add("Column 1").HTMLCaption = "<i>Col</i>umn 1"
End With
353
How can I align the text/caption on the scroll bar

With ComboBox1
	.ScrollPartCaption(1,512) = "left"
	.ScrollPartCaptionAlignment(1,512) = 0
	.ScrollPartCaption(1,128) = "right"
	.ScrollPartCaptionAlignment(1,128) = 2
	.ColumnAutoResize = False
	.Columns.Add 1
	.Columns.Add 2
	.Columns.Add 3
	.Columns.Add 4
	.Columns.Add 5
	.Columns.Add 6
End With
183
How can I align the icon in the column's header in the center

With ComboBox1
	.Images "gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" & _
	"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" & _
	"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _
	"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="
	With .Columns.Add("")
		.HeaderImage = 1
		.HeaderImageAlignment = 1
	End With
End With
177
How can I align the column to the right, and its caption too

With ComboBox1
	With .Columns.Add("Column")
		.Alignment = 2
		.HeaderAlignment = 2
	End With
	.Items.AddItem 0
	.Items.AddItem 1
End With
176
How can I align the column to the right

With ComboBox1
	.Columns.Add("Column").Alignment = 2
	.Items.AddItem 0
	.Items.AddItem 1
End With
304
How can I align the cell to the left, center or to the right

With ComboBox1
	.TreeColumnIndex = -1
	.DrawGridLines = -2
	.Columns.Add "Default"
	With .Items
		.CellHAlignment(.AddItem("left"),0) = 0
		.CellHAlignment(.AddItem("center"),0) = 1
		.CellHAlignment(.AddItem("right"),0) = 2
	End With
End With
135
How can I add several columns to control's sort bar

With ComboBox1
	.SortBarVisible = True
	.SortBarColumnWidth = 48
	.Columns.Add("C1").SortOrder = 1
	.Columns.Add("C2").SortOrder = 2
End With
313
How can I add separator - dividers items

With ComboBox1
	.MarkSearchColumn = False
	.TreeColumnIndex = -1
	.ScrollBySingleLine = False
	.Columns.Add "C1"
	.Columns.Add "C2"
	With .Items
		h = .AddItem("Cell 1")
		.CellCaption(h,1) = "This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines."
		.CellSingleLine(h,1) = False
		h = .AddItem()
		.ItemDivider(h) = 0
		.ItemDividerLine(h) = 4
		.ItemDividerLineAlignment(h) = 1
		.ItemHeight(h) = 6
		.SelectableItem(h) = False
		h = .AddItem("Cell 2")
		.CellCaption(h,1) = "This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines."
		.CellSingleLine(h,1) = False
	End With
End With
226
How can I add or insert child items

With ComboBox1
	.LinesAtRoot = -1
	.Columns.Add "C1"
	.Columns.Add "C2"
	With .Items
		h = .AddItem("Cell 1")
		.CellCaption(h,1) = "Cell 2"
		.CellCaption(.InsertItem(h,,"Cell 3"),1) = "Cell 4"
		.CellCaption(.InsertItem(h,,"Cell 5"),1) = "Cell 6"
		.ExpandItem(h) = True
	End With
End With
223
How can I add or insert an item

With ComboBox1
	.Columns.Add "Default"
	.Items.AddItem "new item"
End With
224
How can I add or insert an item

With ComboBox1
	.Columns.Add "C1"
	.Columns.Add "C2"
	With .Items
		.CellCaption(.AddItem("Cell 1"),1) = "Cell 2"
		h = .AddItem("Cell 3")
		.CellCaption(h,1) = "Cell 4"
	End With
End With
225
How can I add or insert a child item

With ComboBox1
	.LinesAtRoot = -1
	.Columns.Add "Default"
	With .Items
		.InsertItem .AddItem("root"),,"child"
	End With
End With
464
How can I add or change the padding (spaces) for captions in the control's header

With ComboBox1
	.BeginUpdate 
	.Columns.Add("Padding-Left").Def(52) = 18
	With .Columns.Add("Padding-Right")
		.Def(53) = 18
		.HeaderAlignment = 2
	End With
	.EndUpdate 
End With
3
How can I add multiple columns

With ComboBox1
	With .Columns
		.Add "Column 1"
		.Add "Column 2"
	End With
End With
465
How can I add a vertical padding

With ComboBox1
	.BeginUpdate 
	.DrawGridLines = -1
	With .Columns.Add("Padding")
		.Def(0) = True
		.Def(16) = False
		.Def(48) = 6
		.Def(49) = 6
		.Def(50) = 6
		.Def(51) = 6
	End With
	With .Items
		.AddItem "padding"
		.AddItem "padding"
	End With
	.EndUpdate 
End With
1
How can I add a new column

With ComboBox1
	.Columns.Add "ColumnName"
End With
454
How can I add a horizontal scroll bar

With ComboBox1
	.BeginUpdate 
	.ScrollBySingleLine = True
	.ColumnAutoResize = False
	.BackColorAlternate = RGB(240,240,240)
	With .Columns.Add("Default")
		.Width = 512
		.Def(16) = False
	End With
	With .Items
		.AddItem "Exontrol is devoted to create innovative user interface components for Windows applications, on COM or .NET platforms, since 19" & _
	"99. ""eXontrol"" comes from e(s)pecial (c)ontrol, where sc makes the X. We are a vendor not a reseller, and this is the single s" & _
	"ite where you can try or buy our products. If you are tired of looking for ""powerful"" components now it's time to show you rea" & _
	"l components. No registration required, no nag screens, no limitations, unlimited evaluation time."
		.AddItem "A combo box is a commonly-used GUI tool. It is a combination of a drop-down list or list box and a single-line textbox, allowin" & _
	"g the user either to type a value directly into the control or choose from the list of existing options."
	End With
	.EndUpdate 
End With
221
How can I access the properties of a column

With ComboBox1
	.Columns.Add "A"
	.Columns.Item("A").HeaderBold = True
End With
595
Highlight the parent items

With ComboBox1
	.BeginUpdate 
	.ConditionalFormats.Add("%CC0").ForeColor = RGB(255,0,0)
	.HeaderAppearance = 4
	.HeaderHeight = 24
	.LinesAtRoot = -1
	With .Columns
		.Add("Item").Width = 16
		.Add "Desc"
	End With
	With .Items
		hR = .AddItem("Root")
		.CellCaption(hR,1) = "The root directory /"
		h = .InsertItem(hR,,"Home")
		.CellCaption(h,1) = "The home directory with user directories Alice and Bob"
		.InsertItem h,,"Alice"
		.InsertItem h,,"Bob"
		.ExpandItem(h) = True
		h = .InsertItem(hR,,"Etc")
		.CellCaption(h,1) = "The etc directory with one configuration file"
		h = .InsertItem(h,,"nginx.conf")
		.CellCaption(.InsertItem(hR,,"Var"),1) = "The var directory"
		.ExpandItem(hR) = True
	End With
	.EndUpdate 
End With
596
Highlight the leaf items

With ComboBox1
	.BeginUpdate 
	.ConditionalFormats.Add("%CC0=0").ForeColor = RGB(128,128,128)
	.HeaderAppearance = 4
	.HeaderHeight = 24
	.LinesAtRoot = -1
	With .Columns
		.Add("Item").Width = 16
		.Add "Desc"
	End With
	With .Items
		hR = .AddItem("Root")
		.CellCaption(hR,1) = "The root directory /"
		h = .InsertItem(hR,,"Home")
		.CellCaption(h,1) = "The home directory with user directories Alice and Bob"
		.InsertItem h,,"Alice"
		.InsertItem h,,"Bob"
		.ExpandItem(h) = True
		h = .InsertItem(hR,,"Etc")
		.CellCaption(h,1) = "The etc directory with one configuration file"
		h = .InsertItem(h,,"nginx.conf")
		.CellCaption(.InsertItem(hR,,"Var"),1) = "The var directory"
		.ExpandItem(hR) = True
	End With
	.EndUpdate 
End With
594
Highlight the item being expanded or collapsed

With ComboBox1
	.BeginUpdate 
	.ConditionalFormats.Add("%CX0").Bold = True
	.HeaderAppearance = 4
	.HeaderHeight = 24
	.LinesAtRoot = -1
	With .Columns
		.Add("Item").Width = 16
		.Add "Desc"
	End With
	With .Items
		hR = .AddItem("Root")
		.CellCaption(hR,1) = "The root directory /"
		h = .InsertItem(hR,,"Home")
		.CellCaption(h,1) = "The home directory with user directories Alice and Bob"
		.InsertItem h,,"Alice"
		.InsertItem h,,"Bob"
		.ExpandItem(h) = True
		h = .InsertItem(hR,,"Etc")
		.CellCaption(h,1) = "The etc directory with one configuration file"
		h = .InsertItem(h,,"nginx.conf")
		.CellCaption(.InsertItem(hR,,"Var"),1) = "The var directory"
		.ExpandItem(hR) = True
	End With
	.EndUpdate 
End With
589
Force hover-all feature
With ComboBox1
	.Background(500) = -1
End With
515
FilterBarCaption Predefined Keywords

' AfterExpandItem event - Fired after an item is expanded (collapsed).
Private Sub ComboBox1_AfterExpandItem(ByVal Item As Long)
	With ComboBox1
		.Refresh 
	End With
End Sub

With ComboBox1
	.BeginUpdate 
	.LinesAtRoot = -1
	.Columns.Add("Item").DisplayFilterButton = True
	With .Columns.Add("Check")
		.Def(0) = True
		.DisplayFilterButton = True
		.DisplayFilterPattern = False
		.FilterType = 6
	End With
	With .Columns.Add("Pos")
		.AllowSizing = False
		.AllowSort = False
		.Width = 32
		.FormatColumn = "1 apos ``"
		.Position = 0
	End With
	With .Items
		.AddItem "Item A"
		h = .AddItem("Item B")
		.CellState(.InsertItem(h,,"Sub-Item B1"),1) = 1
		.InsertItem h,,"Sub-Item B2"
		.ExpandItem(h) = True
		.AddItem "Item C"
	End With
	.FilterInclude = 1
	.FilterBarFont = .Font
	.FilterBarCaption = "`<fgcolor=0000FF><i>value/current</i></fgcolor>: <fgcolor=808080>` + value + `</fgcolor>` + `<br><fgcolor=0000FF><i>available</" & _
	"i></fgcolor>: ` + available + `<br><fgcolor=0000FF><i>allui</i></fgcolor>: ` + allui + `<br><fgcolor=0000FF><i>all</i></fgcolor>" & _
	": ` + all + `<br><fgcolor=0000FF><i>itemcount</i></fgcolor>: <fgcolor=808080>` + itemcount + `</fgcolor>`+ `<br><fgcolor=0000FF>" & _
	"<i>visibleitemcount</i></fgcolor>: <fgcolor=808080>` + visibleitemcount + `</fgcolor>`+ `<br><fgcolor=0000FF><i>matchitemcount</" & _
	"i></fgcolor>: <fgcolor=808080>` + matchitemcount + `</fgcolor>`+ `<br><fgcolor=0000FF><i>promptpattern</i></fgcolor>: <fgcolor=8" & _
	"08080>` + promptpattern + `</fgcolor>`+ `<br><fgcolor=0000FF><i>leafitemcount</i></fgcolor>: <fgcolor=808080>` + leafitemcount +" & _
	" `</fgcolor>`"
	.FilterBarPromptPattern = "B"
	.FilterBarPromptVisible = 7 ' FilterBarVisibleEnum.exFilterBarCaptionVisible Or FilterBarVisibleEnum.exFilterBarVisible Or FilterBarVisibleEnum.exFilterBarPromptVisible
	With .Columns.Item(0)
		.FilterType = 240
		.Filter = "Item A|Item B"
	End With
	.ApplyFilter 
	.EndUpdate 
End With